Write Range
AutomatR.GoogleSheets.Activities.WriteRange
The "Write Range" activity in AutomatR is part of the Google Sheets activities package, tailored for seamless integration with Google Sheets. This custom activity enables you to write data from a DataTable to a specific range in a Google Sheets spreadsheet. This feature facilitates the efficient transfer of structured data from your workflow to Google Sheets.
Properties
| Name | Description |
|---|---|
| Input | |
| Starting Cell | Specifies the cell value from which the data writing should begin. Default value is "A1". String variables containing the starting cell value. |
| Data Table | Specifies the DataTable containing the data to be written to the spreadsheet. DataTable variables containing the data to be transferred. |
| Miscellaneous | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Write Range" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Ex.: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
| Header | When enabled, considers the column headers as the first row in the specified cell range. Boolean variables controlling the inclusion of headers. |
| Output | |
| Result | Outputs the range in the spreadsheet that has been modified due to the activity. For example, "A1:L32". String variables to store the modified range information. |
How to use:
- Drag and drop the "Write Range" activity onto the workflow.
- Configure the properties by specifying the starting cell, data table, and optionally set a delay or include headers.
- Place the "Write Range" activity within a "Google Sheets App Scope" to ensure proper authentication and access to the Google Sheets service.
- Execute the workflow to write the data from the specified DataTable to the designated range in the Google Sheets spreadsheet.
Example: Consider an example where the "Write Range" activity is used to write data from a DataTable named "EmployeeData" starting from cell "A1" in a Google Sheets spreadsheet:
Write Range:
Starting Cell: "A1"
Data Table: EmployeeData
Header: True
Delay: 1
Result: ModifiedRange
In this example, the activity writes data from the "EmployeeData" DataTable to the Google Sheets spreadsheet starting from cell "A1". Headers are included, and the modified range information is stored in the string variable "ModifiedRange" for further handling in the workflow.